SELECT ORG_MEMBER."ID" oaId,ORG_MEMBER.name username,ORG_PRINCIPAL.LOGIN_NAME loginName,
CASE WHEN PERSON_SECRET_LEVELS.PWD_STRENGTH = 1 THEN '2' 
WHEN PERSON_SECRET_LEVELS.PWD_STRENGTH = 2 THEN '3' 
WHEN PERSON_SECRET_LEVELS.PWD_STRENGTH = 3 THEN '4' END secretLevel,
'n' delMark,ORG_MEMBER.ORG_DEPARTMENT_ID deptId,ORG_POST."NAME" duty,ORG_MEMBER.SORT_ID pos
FROM ORG_MEMBER 
LEFT JOIN ORG_PRINCIPAL ON ORG_PRINCIPAL.MEMBER_ID = ORG_MEMBER."ID"
LEFT JOIN PERSON_MEMBER_MAP ON PERSON_MEMBER_MAP.MEMBER_ID = ORG_MEMBER."ID"
LEFT JOIN PERSON_SECRET_LEVELS ON PERSON_SECRET_LEVELS.PSL_ID = PERSON_MEMBER_MAP.PSL_ID
LEFT JOIN ORG_POST ON ORG_POST."ID" = ORG_MEMBER.ORG_POST_ID
WHERE ORG_MEMBER.IS_DELETED = 0 AND ORG_MEMBER.IS_ENABLE = 1 AND ORG_MEMBER.ORG_DEPARTMENT_ID != -1
ORDER BY ORG_MEMBER.SORT_ID